UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S9mgWYoovP1TA9hpV+8fu6dzpvSm8YCRhgco5sKdA8w='
WHERE
key_id = 'c3449c2f688224d23104e0ff2017f4325ea16990e04425f530a6f4fd1fb47557'
AND (
token = 'S9mgWYoovP1TA9hpV+8fu6dzpvSm8YCRhgco5sKdA8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)