UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z3eTZFUQY0cHj4C3S3Hsd38HgtfmoxTeA5wwuo3NSGw='
WHERE
key_id = 'fbb0918b2face83fb5253bc52b959a9606033aa25e6e42c823471173621bf899'
AND (
token = 'Z3eTZFUQY0cHj4C3S3Hsd38HgtfmoxTeA5wwuo3NSGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)