UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Qe7S/C7HmKxLnK38WqUOxx9ID30lTgp6qoXdCk8wKY='
WHERE
key_id = '0e4a0a866e764df3af24b0e6339969b7ac3d5bd6b512011fc19176882b8d15f2'
AND (
token = '8Qe7S/C7HmKxLnK38WqUOxx9ID30lTgp6qoXdCk8wKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)