UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dZzQqX1RRhMYmQUe1hzj2h8qD/JvRf1EqoLFod3Rh4I='
WHERE
key_id = 'b9ce1bcd7b6ef312b0adc604b9198354583f65326b5621a5e890c2ae3bf1cd3e'
AND (
token = 'dZzQqX1RRhMYmQUe1hzj2h8qD/JvRf1EqoLFod3Rh4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)