UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XouNq8lUPOJFsoSVeWu/uenXP7JZWn4Wf+8Hj0gJAQ0='
WHERE
key_id = 'ead1f9ab83b3f00ad8f4399f4a41e621c0d0e3f29a5f6a222968336e8cf2ebff'
AND (
token = 'XouNq8lUPOJFsoSVeWu/uenXP7JZWn4Wf+8Hj0gJAQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)