UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j7GRnK1RSSjC/qCaGU1EG0BALHoxrA/bvA6CdEAZues='
WHERE
key_id = '86d23638abbd9bbc801e5568b752a5e711ac7386fb67a2709dd0959123a89420'
AND (
token = 'j7GRnK1RSSjC/qCaGU1EG0BALHoxrA/bvA6CdEAZues='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)