UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G28ejz9z+bQYnp1tdrWUVfomEnMrpKADonFA1RCeuwo='
WHERE
key_id = 'dd50826b37622f5dac8a93847dd4ac2cebd7835b5e285b59c80923689a549f1d'
AND (
token = 'G28ejz9z+bQYnp1tdrWUVfomEnMrpKADonFA1RCeuwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)