UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '430k8a9tE11JioYRDnsL3YOEGpT7rs84Ueo6s0OIEdc='
WHERE
key_id = 'b23f4eb78fa931b67786cc41815ea4f96e866896f6234d3b55a4c05a4f43d36f'
AND (
token = '430k8a9tE11JioYRDnsL3YOEGpT7rs84Ueo6s0OIEdc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)