UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NCqncbyfCld5VAGwgrq56rToB+SBGGy/aWILuZ+Tw9o='
WHERE
key_id = '6c7ef4f4e6cea66f8f43841ecd4d1fe6092d3add181121feeea82f2d825f997f'
AND (
token = 'NCqncbyfCld5VAGwgrq56rToB+SBGGy/aWILuZ+Tw9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)