UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a20Pv6SDr7q9A1JsCmBQZOUS1c/3MJ9jHu8sG2McaXc='
WHERE
key_id = '8fa083a6079a91628da0dcfe117e72e6eb3700d2afc8fc81c15439fef8bde997'
AND (
token = 'a20Pv6SDr7q9A1JsCmBQZOUS1c/3MJ9jHu8sG2McaXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)