UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mG+sPyUIhw2ro3PIVirWqW86z7fdfuXnUAiaZjy6/CI='
WHERE
key_id = 'a05cfdb804b9e2aadd1395fce8b89feefa9fb469268db8c808debc6f22f5fad9'
AND (
token = 'mG+sPyUIhw2ro3PIVirWqW86z7fdfuXnUAiaZjy6/CI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)