UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5eiHEWQS2tSc+A0VzzoQBJhZcB53si1wD0UmDdu2y0I='
WHERE
key_id = 'a7bb13d51685f17515be40831185ad4c6558c791d65da9b660af528734023521'
AND (
token = '5eiHEWQS2tSc+A0VzzoQBJhZcB53si1wD0UmDdu2y0I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)