UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgP6hPh7vbIWgFXSe2X+wOEOjyJvzRyTgrN/D5Wd/RY='
WHERE
key_id = '339d39a99080779cc01eeced260430f47b7efdedd6fc8a9902426748913bc265'
AND (
token = 'BgP6hPh7vbIWgFXSe2X+wOEOjyJvzRyTgrN/D5Wd/RY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)