UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EPGanP1QnVdWVB45rbPHD38bjtkX6C0RtaSBj59NciA='
WHERE
key_id = '7a9e778046578e156ada56f31f8b6eb227200713e01633290a0d38f59c44b8fa'
AND (
token = 'EPGanP1QnVdWVB45rbPHD38bjtkX6C0RtaSBj59NciA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)