UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VZk9nbLo6iOXau8QRrZik+1pPv/v7fD9sH86bt46PPE='
WHERE
key_id = '2cce3b317ed0e09f29a783b5a5e97389e9847264287f434f7ed3f844b44c66cc'
AND (
token = 'VZk9nbLo6iOXau8QRrZik+1pPv/v7fD9sH86bt46PPE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)