UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QNns5zfGmZzs6cxY6VXcp2n0RPHdBNDTZ1F1swVhJmg='
WHERE
key_id = '58e7b83fcf7ef837a9738d381239930a9da7d8cbee11bd3617b22e993ce220f3'
AND (
token = 'QNns5zfGmZzs6cxY6VXcp2n0RPHdBNDTZ1F1swVhJmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)