UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xp04L9d86YSutzHzoie05yb8CzhSWJpkX8wCSPQvYGM='
WHERE
key_id = '80ee46f50bb48c45054865118d6571f2e45ef85cf4c559b209f078ae424e150c'
AND (
token = 'Xp04L9d86YSutzHzoie05yb8CzhSWJpkX8wCSPQvYGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)