UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7WiFke/3NHPJAyxxvKVRdoeID/ZWJ/uT1v5jGzmkcm4='
WHERE
key_id = 'a1711abbc71d9ec9e3f438f5b70250b540df1b81983785dfb6f8621a3019b034'
AND (
token = '7WiFke/3NHPJAyxxvKVRdoeID/ZWJ/uT1v5jGzmkcm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)