UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CCAgdy227Sb+BmjJ3rqA6v2cmuni46117JJrcEwrwhM='
WHERE
key_id = '8f2fffde6cf84a7af0a595f81c3b5139c3ff2d485eed9cd7977e0aeb3829d09e'
AND (
token = 'CCAgdy227Sb+BmjJ3rqA6v2cmuni46117JJrcEwrwhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)