UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zRKqWh4fK0ZPQh6vPP9gSb/JEy44UgBO9UO0Q0thXHA='
WHERE
key_id = '5eff4811ab48534c2af72cfc40a86fa023c598c661280f4d99f55c6300be68ae'
AND (
token = 'zRKqWh4fK0ZPQh6vPP9gSb/JEy44UgBO9UO0Q0thXHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)