UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lt9OY0jON3HnpAbH9glqf3FFjefcqjWBC8WxQkU7IL8='
WHERE
key_id = '1becf82121204bdb52dac9e042a8d527a19eb8932f6d502def3c5a89c001175a'
AND (
token = 'lt9OY0jON3HnpAbH9glqf3FFjefcqjWBC8WxQkU7IL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)