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