UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nOZ9Cpam3bAL+Qptg5HNiPISbE6qdOOVvSdlIWessH0='
WHERE
key_id = 'c0f2ecaf166abac98b34223d1cd30a5c41dcc69496e0b76d929f31334ae44594'
AND (
token = 'nOZ9Cpam3bAL+Qptg5HNiPISbE6qdOOVvSdlIWessH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)