UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yJ1C3z1bYyZY8oKgNEhWKpIE0kh0b27diHlvIE1m9b0='
WHERE
key_id = 'edd6720c3cfb18ae93dccc875f0723436709d32a5f87048c1c4167adbea359df'
AND (
token = 'yJ1C3z1bYyZY8oKgNEhWKpIE0kh0b27diHlvIE1m9b0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)