UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xSZ8u9LL1IS/MytD5+smJptdEuhFMEbptn7SEN/5DG4='
WHERE
key_id = '8be32c4280dd0f47210a84f92922f3e95ad9e8f2fcb4da027e5237c6a42f9dda'
AND (
token = 'xSZ8u9LL1IS/MytD5+smJptdEuhFMEbptn7SEN/5DG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)