UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zBrnKrkY8BqAfltgeAHyqfXkITIfmhXxSzjUhrenifQ='
WHERE
key_id = '0827dd7048a459c20a1dfc149e3050464a00113805650ec48f4f489e5ab2009e'
AND (
token = 'zBrnKrkY8BqAfltgeAHyqfXkITIfmhXxSzjUhrenifQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)