UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y0Z+SRs4k4VREiPHqDA37EgoXLKoCpYCuig/I5WUynU='
WHERE
key_id = '9fc2eac840ae96a91f8f36861fd278e07182902c6ac263e854fe7c3139af9783'
AND (
token = 'Y0Z+SRs4k4VREiPHqDA37EgoXLKoCpYCuig/I5WUynU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)