UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3SiNw34sJ9fvgny7Y2mOoBvr14AKlqvce3+kwmqXCyg='
WHERE
key_id = 'c671e83ace3f2bcee7d7e02e59e33e33e3c91a8c8e51f9be145d0816e13ca64e'
AND (
token = '3SiNw34sJ9fvgny7Y2mOoBvr14AKlqvce3+kwmqXCyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)