UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PqD4kLOEpKZYDQPOdkWqH5FLBQlQ7ZoRbN6nJ55wnG8='
WHERE
key_id = '8838594b340fbfb3a6e0df0dc3b9b6f8538c73b1a5c49e53308c1544a9434eb2'
AND (
token = 'PqD4kLOEpKZYDQPOdkWqH5FLBQlQ7ZoRbN6nJ55wnG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)