UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xq8SCCCE+zeac+ZEuDPDhRVb1fQ2XzQaTOp9JNnMiio='
WHERE
key_id = 'bfa38cdcaf5b93fbd1700b2cdb35422f1e7ff1ccacc8e16904099f6f88cd586e'
AND (
token = 'Xq8SCCCE+zeac+ZEuDPDhRVb1fQ2XzQaTOp9JNnMiio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)