UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bi6tMt7ThQo8cIkZLRLTn2djv/tigGgnWqJLdqdw8dc='
WHERE
key_id = '8e443d811875959fed4d238d0f08cb76dc28e93298fcc65d873611b16a53edd7'
AND (
token = 'bi6tMt7ThQo8cIkZLRLTn2djv/tigGgnWqJLdqdw8dc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)