UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9NSIq6QldEle75FK5UZNXN/6E8DpVD6eTDJc/ECQoYc='
WHERE
key_id = '59dda8fa6996914feda91e671ae677339ba9956947f8b196ae71f7b5d8a8ecf1'
AND (
token = '9NSIq6QldEle75FK5UZNXN/6E8DpVD6eTDJc/ECQoYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)