UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E1XX0bBt0doY8zkV41VQKOrGGRsXDh2ZgatFjwQAq48='
WHERE
key_id = 'c19f5b0ce71a59d8dd86e040830b73968819ca222458278feebd765f8e59d0c3'
AND (
token = 'E1XX0bBt0doY8zkV41VQKOrGGRsXDh2ZgatFjwQAq48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)