UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p4bqDayflQNmfCCoky70qY5m3Gr8pUfb8VNgWrE3Br4='
WHERE
key_id = '9458148b111c5b1243da18c4ba69560542b896f9470cca4aa99b7b82a6232136'
AND (
token = 'p4bqDayflQNmfCCoky70qY5m3Gr8pUfb8VNgWrE3Br4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)