UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZASI8tI+uVhzlyW6kzve6BUVuZqkUPnw1R8rq2CJeI='
WHERE
key_id = 'c765f3db5b31038c3ca68dbb237031f02f78f21d4207fec1ce1128fd12f504cb'
AND (
token = 'XZASI8tI+uVhzlyW6kzve6BUVuZqkUPnw1R8rq2CJeI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)