UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9TtpatA6s9ZFDT3DU186c/Ufyv+LcqGKxRiM8WwwnbU='
WHERE
key_id = '96580a51c204459ad922f0980136f7c8bd1b78380f3f78341809a64e4eea0fb0'
AND (
token = '9TtpatA6s9ZFDT3DU186c/Ufyv+LcqGKxRiM8WwwnbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)