UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xg2SHAp9l7v3XLIb+M09Q++avj5ZY09kU7890Z7bTRg='
WHERE
key_id = '1e587218103597b00d5b3a627447518461214cbfb21f95c851d1ff94c09a84a2'
AND (
token = 'xg2SHAp9l7v3XLIb+M09Q++avj5ZY09kU7890Z7bTRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)