UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jpx78esWe6h2uR3bqIUATV9q744SuY08Xeftmh8s+LU='
WHERE
key_id = 'ecda1c4dcadb3bf28d0426ae2d879a774ba6d5f972e059d8d9583d67222ac3c4'
AND (
token = 'jpx78esWe6h2uR3bqIUATV9q744SuY08Xeftmh8s+LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)