UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v1LCCxPHSKqsJ79E+MXiXrkiR6l5/yVs2hn4bCkhal4='
WHERE
key_id = 'ed7d6c79ee300ae897ca728b879e91d0411951b14528936ba969a7ba8561182d'
AND (
token = 'v1LCCxPHSKqsJ79E+MXiXrkiR6l5/yVs2hn4bCkhal4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)