UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5ERZJsN3SzP5Ie44hREhCuupNhvKkjzEbvu3+vfGMqk='
WHERE
key_id = 'bd1c9b77e9f750067359355c378b2ddac664b496616938d3e59af65dfea367ae'
AND (
token = '5ERZJsN3SzP5Ie44hREhCuupNhvKkjzEbvu3+vfGMqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)